package com.css.economy.evaluate.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.css.economy.evaluate.entity.EconomyBuildingPrice;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author Dbj
 * @date 2024年09月23日  11:49
 */
@Mapper
public interface EconomyBuildingPriceMapper extends BaseMapper<EconomyBuildingPrice> {
    @Select("select st_astext(ST_intersection(geom,st_geometryfromtext(#{geom},4490))) geomText,* from basic_economy_building_price where ST_Intersects(geom,st_geometryfromtext(#{geom},4490))")
    List<EconomyBuildingPrice> getBuildingPriceByGeom(String geom);
}
